SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413500 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413500 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012652,770777,905577,853443,139708,326020,351810,984467,70795,765428,967251,749475,551662,798946,826367,937378,1009671,471945,291242,803922,41108,215014,372953,971004,874159,540846,849435,257138,409109,844175,763825,480021,235622,708153,628688,794904,429929,1003320,586515,517314,187136,280169,587986,393677,358420,94276,687069,187098,84220,361310,260137,818422,821476,260404,421796,883104,916342,753956,89220,104624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]