SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583723 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583723 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191008,376512,291540,889255,380890,98716,591625,105641,665457,1021811,657237,83130,295568,842058,58149,410313,376963,66544,917153,149820,999599,433413,445858,664695,139988,974288,507417,361678,422417,527696,190309,508666,920234,132860,875451,868102,116693,120728,437083,890778,665379,837434,535642,940403,312018,926854,828271,538628,954611,692662,350094,998450,707778,863644,48465,150922,22813,794777,424762,978597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]