SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105445 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105445 [ RunTime:0.005283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802200,34777,882560,965048,221309,474967,18714,235725,715751,969330,482487,303218,381478,1024215,765033,840957,852280,1020162,488645,604345,174675,585374,860521,24819,520307,862154,155342,1015821,701268,324005,1005309,12782,867285,23075,896219,847881,54033,176548,1003144,331363,5842,847113,547380,248193,6744,358657,589405,93820,621777,444532,310276,231475,376310,222002,672563,729483,138870,44793,992306,97718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]