SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904811 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904811 [ RunTime:0.006128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236228,782432,386801,395523,177182,472742,515804,564837,128843,463305,44867,697086,470835,565788,770275,880859,313213,336346,500009,906271,168668,857475,770864,119168,1014146,908528,464434,1000143,919325,762161,741299,14001,1035108,412577,424713,605550,112473,665323,491763,317273,238196,207666,1740,115760,17797,746978,576240,423604,263309,345993,948489,464896,973369,51911,740169,363403,577676,936859,462282,870262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001327s ]