SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585598 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585598 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007804,19533,815406,73462,216300,643864,1008673,1023096,741720,628165,924790,717604,1011973,22940,1010463,124181,292970,89794,354528,545162,226947,202362,917094,703679,170148,392982,375901,599273,409339,312454,663333,624030,309413,492317,1016391,220874,523609,217657,746405,255582,185834,116810,739999,336054,778416,238718,500538,439740,188650,687732,1046889,566529,85816,72017,780094,774372,578816,406013,659865,201274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]