SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004011 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004011 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772262,650884,69161,611480,46572,454751,263361,33606,593006,962369,240667,304121,358142,505583,20097,820891,107671,542872,805061,724640,842528,979157,308933,379614,404699,609437,690954,239925,277693,33038,284599,461571,606428,998020,468985,695812,215706,670112,695973,431244,402363,121292,1002269,358834,949388,138719,380910,902458,948470,482668,590607,1044918,768864,701825,358329,983494,728116,390763,1037431,784345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]