SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198429 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198429 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536612,161035,381660,309036,476629,572653,922409,1018310,588560,57871,233794,717819,524399,726508,380833,859170,459368,148550,490584,359204,809934,106197,84478,558524,363663,185958,478170,751118,942281,612543,925777,797438,668543,65907,318925,712320,967572,597200,281645,129953,906410,466084,224534,848461,138598,611070,177636,50457,476020,215127,494528,272741,937846,1002741,54299,117571,47582,583878,379475,608824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005528s ]