SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287348 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287348 [ RunTime:0.003341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247015,141119,431084,281670,522907,476993,101129,135977,157112,437072,926203,320764,251424,1015309,266846,108062,325862,355144,521304,842992,412279,251555,112817,983748,868368,873112,109236,503575,188745,615778,644879,873086,29715,31195,609736,699111,985657,838569,813958,875997,376320,858605,865494,534197,56647,233217,987350,968115,938995,877668,490643,172185,620812,66622,239784,597351,924744,182685,327200,946628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]