SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575160 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575160 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346802,796344,346251,450849,158646,155729,278466,829470,77826,781655,532010,196598,182887,884258,430528,645957,152037,796657,457720,534623,1040784,937713,228454,46303,902841,205930,28916,539697,974801,480728,130,79365,624094,781128,970296,343333,852871,319924,109733,966600,110428,240669,35534,912239,154499,348387,1024043,837290,778414,930212,545784,253176,627598,826901,710829,1036285,947636,842213,948575,948902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]