SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015470 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015470 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727499,939055,970602,676330,201286,10471,12192,597560,533484,178087,122848,26070,1012599,870920,919662,957131,616793,214943,63685,428932,726372,759088,723477,421764,512793,279493,838262,1028262,791039,979530,648862,233028,544876,762922,406634,200044,351911,192872,214271,116555,289270,229398,973470,1037213,13096,874215,635379,1040571,884305,979922,231185,624494,444193,132902,175314,657434,778061,632839,555916,88022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]