SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194475 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194475 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340086,1041447,346856,963993,192154,875896,232097,346333,6243,230590,263182,139304,607908,115270,720551,885877,874875,177578,886238,324239,182149,60350,875858,393611,152685,487124,805547,400327,289362,215269,560117,655383,698770,11874,646558,784294,491997,808824,274179,543191,837264,698423,167833,660344,638459,202365,197663,653148,899367,269037,851092,60343,984488,368680,198307,620446,827156,709678,628554,258470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]