SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591143 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591143 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505873,1003909,38257,111846,426186,488254,998585,566609,181057,397318,169800,41284,1761,779836,921692,939448,107119,505478,468831,374199,523190,539356,176448,802094,680416,239957,19299,551552,828939,1029263,342191,221004,254747,741564,395538,641424,20102,829278,477013,994112,894410,1033114,948982,1010064,856728,12591,264352,220750,314628,191006,278740,796096,895064,464580,899259,915081,419987,644601,122955,236715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]