SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029617 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029617 [ RunTime:0.003008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456975,302848,935021,749060,287089,297764,224883,183663,1012266,405547,201657,398536,227183,741484,446898,323411,158275,546194,843888,91702,518448,604532,275924,145578,857348,919419,692021,280610,811092,739354,10549,352966,107042,126818,295608,998061,516905,875200,128776,323037,538886,977933,325888,756305,273156,602572,100450,422510,711924,545122,475871,191835,710209,197443,723199,133476,309433,19637,842861,87791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]