SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285184 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285184 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654618,218967,729378,87686,588235,510841,407101,744012,796147,216857,1014623,914059,1023005,985745,431312,901630,555937,38126,149150,603253,345524,71581,79588,554935,700840,695605,969743,303553,969648,31682,636082,763861,590180,944749,319278,47053,603879,562854,761678,714342,465524,927550,374397,315978,875055,764976,70500,990567,926617,267807,241916,1015311,54410,209434,123565,598111,390872,554665,103700,36083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]