SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002875s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543954 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543954 [ RunTime:0.002761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313895,615139,659992,305306,758293,134835,932415,1009708,644872,305578,147611,944783,826581,694500,262982,645528,35009,976642,551984,268379,521326,706057,203599,520927,366505,751695,246839,232487,348724,551397,974556,864746,240693,41650,842380,1044464,957098,575646,689321,487816,813677,914548,954441,484566,812216,562425,703,693426,424147,992834,811333,237631,654397,773674,847718,598580,83100,64195,755548,413616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]