SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001934s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545213 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545213 [ RunTime:0.002542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439301,577691,400529,447955,773343,569368,359773,382993,96390,580507,93100,29612,722668,322709,302176,823923,42836,860707,397740,645595,522906,1031266,484282,553111,492531,761985,927292,81341,1001524,947905,339670,789180,315116,29299,320394,975838,277520,5165,473028,48810,901773,1019121,994867,511993,571956,864930,286139,705185,298423,84670,596300,924358,230796,266847,362763,972076,405655,981535,216919,671481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]