SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 369743 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 369743 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520187,480310,551948,1039644,187120,408817,527952,708048,266338,753791,835472,976132,661743,75344,65143,330658,269046,128483,453668,314172,112308,598312,962421,250056,505619,590790,940674,266591,278368,776771,1037997,106133,592268,953334,812059,1013810,882608,412474,538403,488897,542142,86836,747430,712762,664751,510961,313179,299414,149264,374607,402741,758848,678732,980307,100540,416425,693797,202689,499728,178616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 369743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 369743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]