SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559836 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559836 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788530,382737,670875,619923,268667,453356,963820,731410,1044885,1021824,446542,902199,247145,590444,769400,467842,441106,626713,102503,155251,540543,569180,686500,741117,490673,918028,470572,431854,460921,29143,527303,812557,762305,235202,367498,1005477,1006621,808852,328248,11261,1009652,714681,777083,839210,132081,147377,93885,310283,510752,950180,731373,495144,983778,66752,334048,1035704,612425,377432,478141,525720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]