SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36438 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36438 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040405,763105,414349,637711,204575,892528,453586,232457,206180,907920,352011,294358,101658,395676,267720,896157,201981,725115,468311,549642,603245,811708,725776,634644,394922,535667,265918,188114,70901,755469,363346,320749,216910,175251,790556,285200,521752,641744,660364,796420,257056,161631,270093,670280,202043,179068,457361,302339,482272,567106,583602,432129,206589,717575,106056,91284,995574,437105,501435,512236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]