SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501658 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501658 [ RunTime:0.006977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311,615404,319824,336844,523546,42053,676783,582930,238622,304873,407041,711503,285642,772308,132140,255918,562615,325181,860821,223099,864161,7961,934338,781707,647367,395249,60117,147676,762603,124176,422597,389925,707673,1042203,713885,220541,980714,509591,469491,911528,533598,676271,199972,666563,658560,248524,819367,99226,330085,569496,159867,487174,394922,878331,77281,343850,149879,1020405,229674,507874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]