SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514439 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514439 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736793,139618,61650,28243,86842,119456,486721,51082,550791,280363,1038702,862550,285291,402835,470262,125136,44421,587026,538910,351243,606621,220056,748527,636229,450224,86246,284344,90382,551827,185214,368774,532774,383654,458704,644020,834288,495487,14992,824769,351222,950607,698986,947808,142206,941464,736952,846526,370880,621630,531701,368047,424038,744388,511828,56276,292693,423326,369563,362651,39075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]