SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2014 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2014 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729198,660446,478373,987039,74747,135314,488102,929018,290994,215382,124832,936790,859259,347692,739873,845021,361283,266215,778402,694072,647177,406599,292955,914894,748409,107149,991023,743450,89755,723178,121136,672809,365509,184856,939163,455250,845661,205195,652316,716141,362883,16479,942051,671555,366027,827817,672799,162473,605481,71592,424548,952538,281639,598702,457635,945309,677223,692704,151187,926573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]