SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002343 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002343 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149050,377589,688055,518642,356486,263326,642586,110219,528569,161339,903903,619220,59158,868557,376032,790329,59688,661202,943487,795138,797639,323317,1010960,552139,633971,59598,627368,252351,502390,194463,699374,387840,613364,491959,86502,50781,732526,33165,237275,908282,244349,562671,950471,750313,966323,494955,885192,70019,970265,908924,516815,772578,874675,1017258,812988,198638,263251,71172,793811,280154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]