SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039640 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039640 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922,293448,326635,486453,714049,771750,476561,735998,927055,101355,860222,390950,1036483,61356,542923,11272,129845,425454,323307,303889,367189,277685,903729,891718,312830,107926,94492,453675,527657,297634,386448,264710,459906,488098,745993,317611,765982,160305,798315,487961,866382,109176,761466,238613,1001783,407036,141016,104635,172647,62291,727499,1047370,539885,100336,8622,780309,102740,270472,501979,1048802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]