SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005533 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005533 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238431,288556,212336,24433,409755,332395,128010,134302,865373,176438,689647,106508,886394,542533,441226,217970,575537,703158,326734,192968,866437,35895,869094,864204,972714,294828,957509,189812,55280,673486,257947,817610,63082,393435,119862,488809,117424,1217,800017,694373,415738,502258,739751,820575,230372,570154,205500,875895,57920,978100,297542,948606,183236,235481,603494,79912,302302,856037,324042,738450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]