SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504906 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504906 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943257,1003191,236498,235957,650666,260286,163807,103219,442301,986791,595326,578078,912580,505971,1046736,418547,118059,498158,957793,124876,1002993,305557,541433,683100,577897,866154,75324,457325,118530,443089,677993,116736,3177,149107,961045,553708,789783,778738,368720,966407,718606,250557,951010,430376,179549,1009873,961907,121962,154471,809010,622113,431570,1041587,497677,548958,1019246,152196,713643,189351,59303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]