SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516983 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516983 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808257,274978,381314,571234,230882,45788,77446,282132,181970,335721,878159,682394,697060,535049,287661,726150,144662,18687,314461,378972,827388,752144,990816,710774,871188,286414,690668,788395,933433,297724,1036299,763573,85140,212250,214603,194508,402844,199488,509287,726481,1019599,973792,426146,1017695,33588,973750,651812,786202,104759,119421,712602,381106,476371,139756,164174,17818,86573,178517,265791,342103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]