SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480975 LIMIT 1 [ RunTime:0.001137s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480975 [ RunTime:0.006854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797395,949276,401415,294288,689719,387417,260314,160621,467745,578407,698602,769196,54793,734840,447123,896604,957935,704990,174530,869732,186302,980185,82516,640332,537344,600358,688247,600142,199107,867407,479840,999447,250762,754310,936540,716213,332012,975196,805398,980086,325254,505999,764982,914274,20310,36696,863980,121954,977092,387335,122484,5513,320807,793700,28504,447691,531119,5350,49905,737245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]