SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536612 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536612 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6187,280433,262777,82134,727124,885292,379325,565299,384579,103805,815403,501816,948175,51333,274337,123085,75129,550339,881287,154040,470342,808302,694153,610657,962789,658123,698657,249363,315876,902307,1016680,157763,92579,866331,721127,69003,1001887,403701,468408,212733,744773,196115,971548,658998,276006,955260,894131,1015183,931322,229343,637520,511764,1015506,856286,417142,705613,268827,820252,817145,979071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]