SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39108 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39108 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169481,891264,428052,566035,159710,883974,251084,799071,35082,778693,974160,422689,813172,504303,1012120,433550,190966,132686,399723,647830,276385,449617,549655,536045,860149,517394,460212,455432,463696,729319,141627,819092,1006209,617996,337354,646567,980991,599233,894529,370082,734721,504520,703463,273864,536661,985365,250861,961138,537726,590090,121447,220100,460584,614081,895688,894357,653197,379757,262530,1033412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]