SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029003 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029003 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317685,763939,869522,52818,268627,573049,800886,612586,807053,745903,669491,694609,257806,597609,35263,186522,361281,57772,1045504,607448,665276,531866,386927,572846,522649,305949,1046259,675360,62694,743338,698235,355328,406856,687305,304085,863391,526445,376357,272797,226815,38999,677294,42728,927926,895519,891350,69599,107465,193688,82398,847551,604542,344496,516687,544329,889980,9287,639588,650556,879036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001053s ]