SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38551 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38551 [ RunTime:0.002732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673412,844395,734780,176424,762252,70850,1020790,925163,90806,657078,510642,907327,827732,16664,640288,529079,860361,543945,582032,274469,275444,253550,309124,679992,705016,876211,116865,495239,699509,991075,408854,362940,309293,877564,507071,232958,337398,980693,715954,368173,166672,305198,749648,370218,1023190,309209,224229,940161,488486,919725,424984,52901,896608,608280,175378,256452,846986,564824,119566,194694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]