SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493311 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493311 [ RunTime:0.002728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678967,988571,961620,1023842,773618,520829,359983,777943,497205,334946,280566,293919,364172,328427,397324,628571,432142,237719,175070,723131,174017,11253,382950,350257,1048618,756177,455362,701708,522281,638176,588682,28029,335032,135969,305169,687535,682253,782770,611191,944840,379132,507034,104835,535105,417560,527214,258055,78829,331131,311777,1035902,305022,621406,176736,384301,22463,433650,548588,62367,140804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]