SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298762 LIMIT 1 [ RunTime:0.002416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298762 [ RunTime:0.006021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670848,602840,393864,718598,971496,854732,74288,267324,680279,484327,301126,303153,98333,524244,854071,38250,269850,327484,282396,780313,610665,791234,940832,950283,1027180,447241,734003,263179,523888,827850,105732,143337,19038,626665,478067,450632,648597,684969,180336,1024331,785822,503373,618156,474480,276620,961130,895163,739545,440073,178952,401864,411147,23597,299449,105893,875427,777963,160343,145738,775180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]