SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003905s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100791 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100791 [ RunTime:0.003892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028353,542521,750579,602345,801629,416768,888081,207770,52177,280624,378910,682024,847380,856022,681242,1009890,955094,53406,53151,679198,711228,45506,867029,766694,420381,34594,982490,439125,425376,160922,540083,601276,882636,436992,196851,786160,27666,968214,1022426,692123,379935,863511,568383,952546,235601,710353,272062,772370,64612,207052,99172,277724,297593,280202,183142,175695,983452,428186,278105,184760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]