SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801207 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801207 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436879,179541,955410,442136,658149,945433,439264,642680,665749,280715,643373,1045515,266368,815717,714526,291868,222979,359651,493418,972553,115337,498586,319318,385177,264086,1033518,900958,277010,469110,548241,1042255,951114,469951,233681,696337,956796,776657,506483,547400,183025,669905,741404,639798,299431,245386,229099,395260,65431,941740,461571,431287,915525,399811,713858,172638,597498,92137,948310,1001206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]