SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048513 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048513 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20831,479689,209879,20902,113868,688059,897790,422506,755305,198826,1009578,923975,16925,645843,416423,1047844,849609,784878,402564,503826,153107,950795,275393,569498,893896,52038,324614,254505,335270,190002,620677,91538,444370,109298,244030,149138,282304,440839,181422,879538,673585,133432,1044273,291111,697950,745286,501186,870912,746759,537921,382560,912809,616045,314497,200190,271682,704137,262907,365694,556902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]