SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548043 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548043 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8211,970552,53643,160348,1466,111043,427595,953869,347937,370767,429293,248299,162693,802606,243647,508488,223807,381963,425552,5103,244271,202246,783279,691698,386121,489181,813720,501773,702500,836525,444958,662158,205233,567071,120203,41142,1017353,698705,548873,73388,1022,104545,491076,938091,1014947,90652,354618,977628,719890,583620,545878,273918,524200,877807,217137,228661,861654,839929,59898,131396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]