SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565020 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565020 [ RunTime:0.003653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885574,106655,463012,923627,504871,978200,105148,517594,837568,531046,978762,134448,238224,574118,735896,510055,757761,725753,306325,644280,358805,1039610,641164,881559,234150,762561,475981,806673,1012739,1004818,475192,355589,1000912,36956,946891,286831,111213,1024253,306360,911309,37655,1039790,729059,562591,493664,117159,62963,354667,1011559,487451,384940,103576,478518,835978,507738,918818,101238,351214,954586,75275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]