SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503084 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503084 [ RunTime:0.002419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672974,216546,370048,542728,428141,192988,175666,917904,370539,141615,1020108,914494,180301,437534,55288,297630,955514,1031771,589777,374601,483072,674670,152315,679355,828193,637848,592451,847119,706933,149017,692952,281131,965991,81446,11609,243173,377674,526949,492681,112501,166777,871763,869943,416563,468684,23603,396156,1011501,455632,546752,251578,657633,407567,907384,224852,364283,164198,499360,147961,626585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001742s ]