SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417650 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417650 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183618,542199,659064,14802,54154,881382,121166,1043675,1022946,992300,211948,200941,989456,853169,209561,327070,309552,244579,528066,712089,475433,413436,700845,1033315,361388,248649,26176,2572,834538,949420,383628,72904,257448,364719,1048288,1006763,1041758,998893,623169,165424,244372,997499,218629,51582,902855,334246,749817,859316,781880,43675,796261,1037022,1010226,92272,287067,1043279,339405,697320,549588,85596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]