SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533800 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533800 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195152,837257,680313,958650,392849,817559,985607,540695,382653,313945,76481,946474,912241,343366,936923,1022353,978038,1017637,577232,104792,774003,941071,234305,850678,853841,322591,652308,202933,824488,739794,342895,667955,517432,487898,417334,25742,454263,90773,807856,414242,146712,338837,807430,399661,1045704,552895,499527,473760,138037,32027,553988,987968,99252,14705,300970,643924,186891,250613,295287,740194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]