SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10176 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10176 [ RunTime:0.002431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639531,324625,572516,196988,573343,669174,43506,249185,302117,277472,182891,934581,952910,317781,1016635,751833,757803,112922,598619,443455,671737,506507,920510,807172,276124,50346,705907,713384,549242,85050,457281,121943,714650,172210,252654,788419,535093,273814,1006396,987661,107869,38560,281878,905226,705086,566827,664330,470069,370681,537667,305966,4992,671921,1041587,445468,100045,719690,1002622,121378,785895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]