SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417380 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417380 [ RunTime:0.002739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823285,265410,468643,733904,706067,501964,41343,484875,991948,90078,650093,1048364,68356,206873,402361,915071,985785,1000834,526083,930806,67302,501956,784834,996503,661948,77968,734504,270774,405443,368277,950929,637174,430163,802378,355374,810866,352721,849378,497816,161859,586530,875034,122434,818511,160870,658922,1015133,828034,71162,803489,903092,646593,371540,701822,8460,1041163,12467,791167,147372,329218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]