SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438743 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438743 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69129,500341,529397,143107,118339,36629,850717,53627,488931,436336,952283,845192,727193,360538,433727,966171,173136,541880,718430,199810,786501,10566,58442,936871,470431,475987,782889,436157,566300,501326,352232,144711,161774,495306,911530,440586,855888,984461,117696,49201,851597,604009,632684,747516,407007,71459,784489,631692,415726,233224,590269,625034,15410,841213,821082,1006933,368871,829531,457441,446659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]