SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535142 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535142 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778928,996207,730214,825470,588782,758252,591054,1017031,389144,501544,164614,1009746,202597,503654,246241,1038696,1025964,363639,944307,460212,21464,533204,682518,486181,602578,852652,9417,256852,515583,465645,407223,460716,567134,980190,718566,40018,282091,229912,1047952,1043284,934624,889973,808411,895932,531393,305382,865925,857732,703673,867066,150946,253791,796289,769766,632472,790087,784687,442787,602112,725287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]