SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560928 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560928 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586412,132898,1015926,588131,941014,281434,797898,489310,555971,52258,501443,530102,628231,218463,356294,751625,648204,388504,214705,727039,750675,74398,900933,383842,331602,269593,106263,549186,265823,860182,1012536,68161,1011433,837740,672422,423863,52367,130758,106579,443979,924939,341523,170523,490759,56960,180765,195151,863365,101282,49943,592458,841502,558811,201741,854475,863699,111902,247703,664080,431428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001621s ]