SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531223 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531223 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189123,518588,579056,191901,538827,849013,920678,134279,566142,715420,916438,1002271,322593,910552,695407,722567,560166,1046277,755534,986279,80861,913659,540571,88108,923443,1488,631866,490077,717624,872056,306836,457374,425277,258999,387986,980267,886380,80354,298646,432797,76565,586097,460130,218451,665998,216432,377687,1047271,110646,551397,786189,4175,658876,852596,314632,527091,125138,172574,575184,1002733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]