SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197875 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197875 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014106,30782,317400,269197,439767,264500,200733,110992,560706,1045794,578879,914392,196578,359548,300297,606043,1031244,658692,9415,730473,900777,111853,918908,36407,239495,1048713,504233,917901,34544,441285,515740,88223,996399,598788,454624,439561,874940,465467,468326,43263,334215,589652,63363,238021,339995,637492,505024,131462,262460,722775,840942,740594,49829,747200,357629,131609,226868,790990,103315,458031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]