SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 933340 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 933340 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533810,205285,982564,656279,1033291,175561,399408,741935,102638,931898,941512,424309,836533,577967,672231,1044819,461566,917177,776324,288578,1018013,2981,840559,142755,972162,70822,181809,393468,412813,385020,694264,972953,335361,475920,263359,26539,836481,865814,43369,82919,661680,201584,742703,509557,56409,683417,573321,115601,66307,172106,319288,685788,580430,551165,440298,840073,876465,226155,463511,682377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 933340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 933340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]