SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538943 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538943 [ RunTime:0.010101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996667,879694,822155,571303,440068,606793,639679,718853,795855,564324,248944,281067,284610,167834,769621,339710,687074,354109,654690,841756,416453,412599,408705,23015,228934,32032,208625,226702,779980,874176,1012908,228972,536915,980345,130239,373495,992122,27991,139283,738933,40018,595489,644963,867179,108399,989295,874044,991754,115982,1042402,632323,138424,952275,60708,255404,394124,755556,734071,299606,437873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000834s ]