SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508417 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508417 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131740,903732,152348,141906,258416,553069,724399,831407,969575,650274,350678,40315,361350,626317,91676,1015680,190623,943906,923015,726701,133209,711879,308396,654778,542305,612522,893971,888265,536922,13987,560754,522119,559272,512076,386676,645664,183659,275442,94946,280813,708685,294843,648412,734339,779395,5738,775520,117803,880069,406453,560434,261486,151164,966860,340541,532915,701,888074,345447,61548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001367s ]