SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914104 LIMIT 1 [ RunTime:0.001216s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914104 [ RunTime:0.004186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485515,375847,190223,359961,85067,30696,591891,729302,451755,95441,326347,862828,537188,585546,109692,316567,347522,94378,431952,795617,863818,842182,613874,1043993,1011371,670843,672872,922631,228255,749829,861144,736615,626117,1028472,1027567,452142,996208,920586,999590,22378,723464,504961,1028761,46195,76915,133313,215599,401610,625453,362331,1031855,30161,555116,675208,753884,567484,936720,889529,816811,405287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]