SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499018 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499018 [ RunTime:0.003477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201226,192541,1003048,424521,987410,324528,856762,254396,294299,497733,438682,893731,1017108,276405,163986,1015422,442362,200580,955920,888084,866740,651742,549482,148043,728986,352235,649235,114126,945546,221424,391429,611640,498560,33172,242518,23359,191239,356207,1042464,942183,790680,701453,924395,1040573,354747,480936,669510,916449,289523,605731,569226,686238,6441,776717,60878,406529,73623,60282,374415,379931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003667s ]