SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341064 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341064 [ RunTime:0.005135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489697,50921,75626,231129,229052,678058,918747,58320,750053,631691,319825,1043376,570212,180628,783646,39027,720017,501467,166034,949029,64991,198501,728223,909421,645615,455500,64875,139524,1008751,490493,144510,478207,343426,475183,495081,449950,669544,610593,510290,817397,969259,1038362,859092,264732,520276,357678,849860,249132,15454,74415,836055,927974,917338,550076,905436,687493,181751,708699,119528,171730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]