SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10607 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10607 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29666,727603,101511,323984,195065,15656,915265,527222,428703,789266,86552,853587,608200,847119,20266,973496,977647,316604,95446,42722,922018,616132,172889,275393,538225,1017258,209620,795018,773969,512897,482532,814,686645,402485,908700,220923,242188,122523,101918,318553,470003,199445,43696,776004,386830,696456,249150,358050,807907,757660,273598,394940,440176,798688,729323,225600,1032308,746742,1046822,185869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]