SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027280 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027280 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106228,75333,858861,486000,538635,705556,308605,796897,572858,65888,327461,746210,984093,708552,965415,946064,604381,771152,163793,287375,537794,432792,180944,845089,1043753,289791,1003488,924710,987983,919326,976090,181433,715495,542408,686666,667804,125765,985904,592012,122797,767882,211320,24737,489039,669686,428475,484337,832028,120679,457190,601176,664524,855841,393064,560890,643915,538522,944896,844981,380582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]