SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505490 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505490 [ RunTime:0.003351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724252,858713,802552,721917,54063,463495,767266,642171,631767,440615,837541,677999,928349,895404,512853,800845,629863,991247,139783,62176,128666,818180,875809,19166,33026,7336,688666,187375,806029,969788,868090,645560,218520,621797,228131,243658,1019705,502952,375984,1025337,811523,300138,741369,292985,20085,560921,744864,218655,977811,1022476,810069,734884,1148,160040,1014186,255514,605834,742655,125741,551459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001494s ]