SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396741 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396741 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617483,504894,773599,764024,766741,440806,344352,316184,200598,93916,280881,1030240,915971,519062,804190,87928,586034,428192,602574,1007390,1042668,548427,363879,53119,890407,708210,610067,798668,840816,208776,74165,750782,67993,385208,486660,636935,293634,131244,17166,925479,625170,148215,718097,916314,879142,388749,302225,294654,889724,178327,41263,434609,911426,816359,870742,945209,713191,790766,665148,726819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]