SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14201 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14201 [ RunTime:0.003547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507512,938538,701331,532742,192726,891037,621293,59851,265253,920294,250956,311615,577141,909067,584045,1002652,329775,864760,201165,572135,20499,10942,436033,386308,87145,985100,113410,973471,2950,372330,340511,374857,444839,279997,410685,411017,321437,349459,380375,519016,1016263,779807,696944,787794,744443,963469,420411,703534,937187,73711,568598,497611,144829,380791,798639,607847,592024,363688,193976,43182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000806s ]