SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414052 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414052 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957713,468049,241066,814050,816027,700930,1005257,100178,1037985,846337,560312,654429,905810,843415,714831,509436,148634,574463,531955,560962,277274,1005813,851612,19100,711805,3445,187924,493817,338007,948716,581046,871770,113191,19343,322729,30651,1042547,500378,840744,407333,101207,875667,787579,457809,474279,967844,131340,654934,416711,781764,873275,804580,719140,437033,630199,160837,649101,958610,1045571,986828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]