SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552580 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552580 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506015,342239,986192,297464,360050,742000,829372,958338,478666,300528,211581,316288,760631,298624,279838,542549,151248,685642,708551,707894,362556,598136,35658,723903,310511,719400,227317,374713,701567,115213,870086,550360,636942,903510,716410,668271,208083,256887,167076,888675,574625,667138,684270,371775,751324,34097,928069,921896,470009,925153,871646,716118,517009,624269,575283,151394,140057,202078,1048426,661932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000975s ]