SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538309 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538309 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744270,501199,525791,145265,44714,559904,1012844,834874,654335,24042,861708,866820,552126,522816,1045608,504769,51035,120319,188064,535184,598969,160180,701326,727709,309805,5017,679612,849727,708436,770826,758564,256650,353035,1004010,752701,925763,597229,25583,973318,137482,601617,271088,908578,887080,366128,163710,56840,422913,724859,255717,627686,585544,36022,100173,530173,890365,1024666,297735,629117,918599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]