SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405599 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405599 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402193,193438,962494,959579,102148,293419,460966,789810,250468,960400,140933,449324,499164,232054,1013679,816325,510847,925356,1008071,1004531,152840,828310,516925,147093,40288,783897,297717,6708,234092,822758,560714,251943,708354,864376,403979,6090,442765,178203,953880,927763,191331,516173,173324,621640,413885,675218,510353,185247,540265,1029502,17833,899229,298106,406569,63168,253691,541518,1017336,55726,569040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003937s ]