SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 902410 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 902410 [ RunTime:0.002677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413068,124615,240210,739788,67408,312344,368195,647893,453632,410650,61751,691537,782279,211512,894343,96503,671622,729851,368435,239407,485530,556368,422284,924637,902008,750699,679569,363553,603552,308641,913509,260286,1047820,595227,155242,490549,586762,181008,499199,383320,843058,409921,38423,591860,805589,511510,498436,506624,65824,16407,827221,630301,282268,63755,223543,393224,272014,618158,243263,590505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 902410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 902410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]